Reviewing Oracle Retail Order Management System Data Source Configuration

Purpose: Use the tomee.xml file on the Oracle Retail Order Management System application server to configure the data source for Oracle Retail Order Management System.

Important: The system updates the tomee.xml file during the installation process and you would typically not change the contents of this file. However, if you receive an error that the Oracle Retail Order Management System application server cannot connect to the database, you should review the contents of this file to make sure it is configured correctly.

If the application server cannot connect to the database: Check the configuration settings in the tomee.xml File, specifically, the connection-url. Also, check the configuration settings in the DBConfig Properties File.

tomee.xml File

Location of file: This file is normally saved on the application server at /usr/local/tomcat01/conf/tomee.xml, where /usr/local/tomcat01 is the installed location of Oracle Retail Order Management System.

To review the file: You can review the contents of this file using a text editor, being careful not to change the settings in this file.

The settings in this file that you might review for troubleshooting purposes are explained below. The additional settings in this file should not be changed.

Setting	Description
id	The name of the datasource. Oracle Retail Order Management System uses two datasources: • SerenadeSeamDatasource = the main database access. • CWDirectCPDS = the secondary database access, used for mapped tables and classes.
jdbcUrl This setting is defined for the SerenadeSeam Datasource and the CWDirectCPDS Datasource.	The information used to connect to the Oracle Retail Order Management System database. jdbc:oracle:thin:@//hostname:9999/servicename where: • hostname = The Hostname defined for the database connection. • 9999 = The default port used to connect to the Oracle Retail Order Management System database server. • servicename = The Service name defined for the database connection.
password	The database password for the userName.
password Cipher	Should be set to PlainText.
userName	The user ID for access to the database.